USE LMR; 

CREATE TABLE SavedLoggers
(
ID int IDENTITY(1,1) PRIMARY KEY,
LoggerName varchar(50) NOT NULL,
LoggerIpAddress char(15) NOT NULL,
LoggerDescription varchar(50),
DisplayF bit DEFAULT 1,
RecInterval int DEFAULT 300,
LastDownloadedThrough datetime NOT NULL DEFAULT '1900-01-01 00:00:00.000',
Ch1Enabled bit DEFAULT 0,
Ch1TempHigh decimal(5,2) NOT NULL DEFAULT 22.77,
Ch1TempLow decimal(5,2) NOT NULL DEFAULT 19.44,
Ch1HumidHigh decimal(5,2) NOT NULL DEFAULT 50.0,
Ch1HumidLow decimal(5,2) NOT NULL DEFAULT 20.0,
Ch2Enabled bit DEFAULT 0,
Ch2TempHigh decimal(5,2) NOT NULL DEFAULT 22.77,
Ch2TempLow decimal(5,2) NOT NULL DEFAULT 19.44,
Ch2HumidHigh decimal(5,2) NOT NULL DEFAULT 50.0,
Ch2HumidLow decimal(5,2) NOT NULL DEFAULT 20.0,
);

